{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Nov 14 Calculator"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Nov 14 Calculator","index":0,"n_rows":40,"n_cols":35,"rows_kept":40,"cut":false,"hidden":false,"merged":[[6,30,7,30],[6,31,7,31],[0,0,0,25]]}
["Nov 14 Calculator"]
[null,"q1","q2","q3a","q3b and c","q3d and e","q4a","q4b","q5a","q5b","q6","q7","q8","q9","q10","q11","q12","q13","q14","q15","q16","q17","q18a","q18b","q19","q20","q21","q22a","q22b","q23"]
[null,"Proportion Recipe Questions","Scattergraphs","Substitution","Expanding and Factorising ","Index Notation","Reflections ","Translations ","Probability","Probability and Relative Frequency","Excchange Rates","Sequences","Frequency Polygons","Percentages","Trial and Improvement","Area and Circumference of Circles","Drawing Straight Line Graphs","Tricky Volume and Rate of Change Qn","Compound Measures","Solving Simultaneous Equations ","Trigonometry","Circle Theorems","Averages from Frequency Tables","Histograms","Tree Diagrams","Solving Quadratics Using the Formula","Sine, Cosine Rules & Area of Triangles","Algebraic Fractions","More Difficult Rearranging Formulae","Upper and Lower Bounds"]
["Max Mark",4,3,2,3,2,2,2,2,2,3,3,2,3,4,4,4,6,4,4,5,4,4,3,5,3,5,3,4,5]
["Class Average (%)",{"$f":"AVERAGE(B9:B40)/B4","v":0.44642857142857145},0.51190476190476197,0.375,0.51190476190476197,0.5535714285714286,0.5357142857142857,0.5535714285714286,0.48214285714285715,0.42857142857142855,0.48809523809523808,0.40476190476190471,0.5535714285714286,0.5714285714285714,0.42857142857142855,0.5714285714285714,0.5267857142857143,0.5714285714285714,0.5089285714285714,0.5625,0.50714285714285712,0.5089285714285714,0.5892857142857143,0.39285714285714285,0.4642857142857143,0.45238095238095238,{"$f":"AVERAGE(AA9:AA40)/AA4","v":0.5357142857142857},0.4285714285714286,0.6875,0.57857142857142851]
["Standard Deviation",{"$f":"IF(COUNT(B9:B36)<2,\"\",STDEV(B9:B40)/B4)","v":0.31444500532789732},0.32052096041759792,0.3227486121839514,0.33311280182832437,0.31444500532789738,0.30210898905832184,0.28347335475692048,0.34646743359179161,0.3779644730092272,0.35696644673093686,0.30573587752790826,0.36866339445719104,0.31239342685979915,0.31810450514017585,0.31810450514017591,0.23901113520361925,0.34074649178491506,0.2762357995105213,0.30142408908625978,0.26933191890246233,0.31536386140356198,0.26539877154295177,0.32777553581871594,0.27245697684736253,0.27538653290313447,{"$f":"IF(COUNT(AA9:AA36)<2,\"\",STDEV(AA9:AA40)/AA4)","v":0.28830832995543704},0.33771372269276084,0.30900827029565259,0.26297041497750107]
[null,"q1","q2","q3a","q3b and c","q3d and e","q4a","q4b","q5a","q5b","q6","q7","q8","q9","q10","q11","q12","q13","q14","q15","q16","q17","q18a","q18b","q19","q20","q21","q22a","q22b","q23","Total Marks","Grade"]
["Name"]
["Sample student 1",{"$f":"ROUND(RAND()*B$4,0)","v":0},{"$f":"ROUND(RAND()*C$4,0)","v":2},1,2,1,2,2,0,1,3,2,1,0,3,3,1,3,2,4,4,4,0,1,1,2,1,0,4,5,{"$f":"IF(AD9=\"\",\"\",SUM(B9:AD9))","v":55},{"$f":"IF(AE9=\"\",\"\",VLOOKUP(AE9,$AH$13:$AI$34,2))","v":"B2"}]
["Sample student 2",{"$f":"ROUND(RAND()*B$4,0)","v":3},0,1,1,2,2,1,0,0,2,1,0,2,2,1,3,4,1,4,1,3,3,0,4,2,5,0,3,2,{"$f":"IF(AD10=\"\",\"\",SUM(B10:AD10))","v":53},{"$f":"IF(AE10=\"\",\"\",VLOOKUP(AE10,$AH$13:$AI$34,2))","v":"B3"},null,"Grade Boundaries"]
["Sample student 3",0,2,2,2,0,2,1,1,0,0,3,0,3,0,1,4,6,2,2,1,3,3,3,5,1,2,2,3,2,56,"B2"]
["Sample student 4",3,2,0,1,2,0,1,1,0,1,2,1,2,0,4,1,6,1,3,4,2,3,0,1,0,0,0,4,1,46,"C1",null,"Non- Calc"]
["Sample student 5",0,1,1,2,1,1,1,1,0,2,1,1,3,2,2,1,3,2,3,3,0,2,2,3,3,2,1,3,5,52,"B3",null,0,"F3"]
["Sample student 6",2,2,2,2,1,1,1,1,0,1,0,0,0,4,3,1,1,2,3,4,1,1,2,3,1,4,0,4,3,50,"B3",null,2.3333333333333335,"F2"]
["Sample student 7",2,1,1,1,2,1,1,1,2,3,1,2,3,2,2,2,1,1,2,2,3,3,0,3,2,2,3,3,4,56,"B2",null,4.666666666666667,"F1"]
["Sample student 8",3,1,0,0,0,1,1,1,0,0,0,2,1,3,4,2,6,3,1,0,1,2,1,0,1,4,0,1,3,42,"C1",null,7,"E3"]
["Sample student 9",4,3,1,1,1,1,1,0,0,3,3,0,2,0,2,2,6,4,2,4,1,1,0,2,2,3,1,4,3,57,"B2",null,9.3333333333333339,"E2"]
["Sample student 10",1,2,0,3,{"$f":"ROUND(RAND()*F$4,0)","v":1},1,1,0,1,3,2,2,3,1,1,2,6,0,3,2,{"$f":"ROUND(RAND()*V$4,0)","v":3},4,0,4,2,3,2,3,3,59,"B2",null,11.666666666666668,"E1"]
["Sample student 11",0,1,1,0,1,1,2,2,1,2,1,2,1,2,3,1,4,3,0,4,1,3,0,2,1,4,2,4,4,53,"B3",null,14,"D3"]
["Sample student 12",3,3,1,3,1,1,2,0,1,2,1,1,1,4,3,1,2,3,2,5,1,2,1,1,0,4,2,3,2,56,"B2",null,18.666666666666668,"D2"]
["Sample student 13",4,0,1,0,1,1,1,1,2,1,1,1,2,1,1,3,1,4,1,2,1,3,1,4,2,1,2,4,3,50,"B3",null,23.333333333333336,"D1"]
["Sample student 14",1,1,1,2,1,2,0,0,2,0,1,1,2,1,3,3,5,3,1,4,3,1,1,4,2,0,3,4,3,55,"B2",null,29,"C3"]
["Sample student 15",0,1,1,0,0,1,1,2,2,3,0,2,0,1,0,1,1,3,1,1,1,1,2,3,0,3,2,2,3,38,"C2",null,34.333333333333336,"C2"]
["Sample student 16",2,1,0,1,1,1,0,2,0,1,1,1,1,1,4,3,6,1,1,2,0,3,0,3,1,2,0,0,4,43,"C1",null,40.666666666666664,"C1"]
["Sample student 17",1,2,0,1,1,0,1,1,2,1,0,2,3,1,3,2,1,3,1,3,3,4,2,3,2,4,1,3,2,53,"B3",null,48,"B3"]
["Sample student 18",2,1,0,2,1,1,0,0,1,2,2,2,2,0,1,2,6,1,4,2,2,4,1,2,1,5,3,1,3,54,"B2",null,53.333333333333336,"B2"]
["Sample student 19",3,0,0,1,1,2,2,1,1,0,1,2,2,3,1,2,5,1,2,4,3,3,2,1,0,0,1,0,4,48,"B3",null,59.666666666666664,"B1"]
["Sample student 20",1,1,0,3,1,1,2,2,1,1,2,0,1,3,2,2,3,2,2,1,0,1,2,2,0,2,2,2,1,43,"C1",null,67,"A3"]
["Sample student 21",3,1,1,1,1,1,2,1,1,3,1,1,2,3,4,2,3,2,3,3,4,2,2,4,1,3,2,2,1,60,"B1",null,71.333333333333329,"A2"]
["Sample student 22",0,3,1,1,2,1,1,1,1,0,1,1,1,2,2,2,3,3,3,3,3,3,3,0,2,4,0,3,3,53,"B3",null,76.666666666666671,"A1"]
["Sample student 23",2,0,1,2,2,1,1,1,2,1,0,1,2,0,4,4,2,3,2,1,3,3,0,3,1,2,2,3,0,49,"B3",null,64," A*3"]
["Sample student 24",3,3,0,1,2,0,1,2,1,2,1,1,1,1,2,3,6,3,0,3,2,3,1,1,1,2,1,3,3,53,"B3",null,88,"A*2"]
["Sample student 25",2,3,1,3,2,2,1,2,0,0,1,1,1,0,4,1,0,0,4,1,1,3,3,2,2,2,1,4,2,49,"B3",null,94,"A*1"]
["Sample student 26",2,2,0,3,0,1,{"$f":"ROUND(RAND()*H$4,0)","v":1},1,1,1,0,2,2,3,1,2,3,2,4,2,3,2,1,2,2,4,2,4,5,58,"B2",null,100,"A*1"]
["Sample student 27",{"$f":"ROUND(RAND()*B$4,0)","v":2},2,2,3,1,0,1,1,0,1,3,1,2,2,0,2,1,1,2,4,1,1,1,2,2,3,0,1,2,44,"C1"]
["Sample student 28",1,2,1,1,1,1,1,1,1,2,2,0,3,3,3,4,2,1,3,1,4,2,1,0,2,4,1,2,5,55,"B2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]